﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Entity;

namespace CDNC_Hw4_AirTicket.Models
{
    public class SampleLocationData : DropCreateDatabaseIfModelChanges<AirTicketEntities>
    {
        protected override void Seed(AirTicketEntities context)
        {
            var locations = new List<Location>
            {
                new Location{ Code = "DAD", Country="VietNam", Name="Đà Nẵng"},
                new Location{Code = "HAN", Country = "VietNam", Name="Hà Nội"},
                new Location{Code = "HPH", Country = "VietNam", Name="Hải Phòng"},
                new Location{Code = "CXR", Country = "VietNam", Name="Nha Trang"},
                new Location{Code = "SGN", Country = "VietNam", Name="Tp. HCM"},
                new Location{Code = "VII", Country = "VietNam", Name="Vinh"},

                new Location{Code = "ADL", Country="Australia", Name="Adelaide"},
                new Location{Code = "BNK", Country="Australia", Name="Ballina Byron"},
                new Location{Code = "BNE", Country="Australia", Name="Brisbane"},
                new Location{Code = "CNS", Country="Australia", Name="Cairns"},
                new Location{Code = "DRW", Country="Australia", Name="Darwin"},
                new Location{Code = "OOL", Country="Australia", Name="Gold Coast"},
                new Location{Code = "HTI", Country="Australia", Name="Hamilton Island"},
                new Location{Code = "HIS", Country="Australia", Name="Hayman Island"},
                new Location{Code = "HBA", Country="Australia", Name="Hobart"},
                new Location{Code = "LST", Country="Australia", Name="Launceston"},
                new Location{Code = "MKY", Country="Australia", Name="Mackay"},
                new Location{Code = "VIZ", Country="Australia", Name="Melbourne (all airport)"},
                new Location{Code = "AVV", Country="Australia", Name="Melbourne (Avalon)"},
                new Location{Code = "NTL", Country="Australia", Name="Newcastle"},
                new Location{Code = "PER", Country="Australia", Name="Perth"},
                new Location{Code = "MCY", Country="Australia", Name="Sunshine Coast"},
                new Location{Code = "TSV", Country="Australia", Name="Townsville"},
                new Location{Code = "PPP", Country="Australia", Name="Whitsunday Coast - Properpine"},

                new Location{Code = "PNH", Country="Combodia", Name="Phnom Penh"},
                new Location{Code = "REP", Country="Combodia", Name="Siem Reap"},

                new Location{Code = "PEK", Country="China", Name="Beijing"},
                new Location{Code = "CAN", Country="China", Name="Guangzhou"},
                new Location{Code = "HAK", Country="China", Name="Haikou"},
                new Location{Code = "HGH", Country="China", Name="Hangzhou"},
                new Location{Code = "NNG", Country="China", Name="Nanning"},
                new Location{Code = "NGB", Country="China", Name="Ningbo"},
                new Location{Code = "SWA", Country="China", Name="Shantou / Jieyang"},

                new Location{Code = "NAN", Country="Fiji", Name="Fiji - Nadi"},

                new Location{Code = "HKG", Country="HongKong", Name="Hong Kong"},

                new Location{Code = "DPS", Country="Indonesia", Name="Denpasar (Bali)"},
                new Location{Code = "CGK", Country="Indonesia", Name="Jakarta"},
                new Location{Code = "MES", Country="Indonesia", Name="Medan"},
                new Location{Code = "SUB", Country="Indonesia", Name="Surabaya"},

                new Location{Code = "FUK", Country="Japan", Name="Fukuoka (Fukuoka airport)"},
                new Location{Code = "OKA", Country="Japan", Name="Okinawa (Naha Airport)"},
                new Location{Code = "KIX", Country="Japan", Name="Osaka (Kansai)"},
                new Location{Code = "CTS", Country="Japan", Name="Sapporo (New Chitose Airport)"},
                new Location{Code = "NRT", Country="Japan", Name="Tokyo (Narita Airport"},

                new Location{Code = "KUL", Country="Malaysia", Name="Kuala Lumpur"},
                new Location{Code = "PEN", Country="Malaysia", Name="Penang"},

                new Location{Code = "RNG", Country="Myanmar", Name="Yangoon"},

                new Location{Code = "AKL", Country="New Zealand", Name="Auckland"},
                new Location{Code = "CHC", Country="New Zealand", Name="Christchurch"},
                new Location{Code = "DUD", Country="New Zealand", Name="Dundedin"},
                new Location{Code = "ZQN", Country="New Zealand", Name="Queenstown"},
                new Location{Code = "WLG", Country="New Zealand", Name="Wellington"},

                new Location{Code = "MNL", Country="Philippines", Name="Manila"},

                new Location{Code = "SIN", Country="Singapore", Name="Singapore"},

                new Location{Code = "TPE", Country="Taiwan", Name="Tapei"},

                new Location{Code = "BKK", Country="Thailand", Name="Bangkok"},
                new Location{Code = "HKT", Country="Thailand", Name="Phuket"},

                new Location{Code = "HNL", Country="USA", Name="Honolulu"},
            };

            base.Seed(context);
        }
    }
}
